Edit Data

This section illustrates how to edit source data, including renaming fields, and appending/ deleting/modifying data, etc.

Source data

Even after data is imported, you can still redefine the import configurations. Click Edit -> Source data or Edit Source Data icon on the toolbar to enter the Import window.

Rename Field

Select a field or a cell in the source data, right-click to select Rename field to change field name.

Sort

Select a field or a cell in the source data, and right-click to choose Sort by [field] in ascending order/ Sort by [field] in descending order to sort data by the current field.

Insert Row

The item is used to insert a row above the currently selected row or cell.

Select a row or any cell in the source data, click Edit -> Insert Row or right-click to select Insert Row, or use the hotkey Ctrl+Enter to insert a row before the current position.

Insert Column

The item is used to insert a column to the left of the currently selected column or cell.

Select a column or any cell in the source data, click Edit -> Insert Column or right-click to select Insert Column, or use the hotkey Ctrl+ Shift+Insert to insert a column to the left of the current position.

Append Row

The item is used to insert a row after the last row.

Click Edit -> Append Row or right-click to select Append Row, or use the hotkey Alt+Enter to insert a row below the last row.

Append Column

The item is used to insert a column after the last column.

Click Edit -> Append Column or right-click to select Append Column, or use the hotkey Alt+Shift+Insert to insert a column to the right of the last column.

Delete Row

The item is used to delete a selected row or a row holding a selected cell.

Select a row or a cell in the source data, and click Edit -> Delete Row or right-click to select Delete Row or use the hotkey Alt+Shift+Delete to delete the current row.

Delete Column

The item is used to delete a selected column or a column holding a selected cell.

Select a column or a cell in the source data, and click Edit -> Delete Column or right-click to select Delete Column or use the hotkey Ctrl+Shift+Delete to delete the current column.

Shift Row

The item is used to move a selected row or a row holding a selected cell up or down.

Select a row or a cell in the source data, and click Edit -> Shift Row Up/Shift Row Down or press hotkey Alt+Up/Alt+Down to move the current row up or down.

Shift Column

The item is used to move a selected column or a column holding a selected cell to the left or to the right.

Select a column or a cell in the source data, and click Edit -> Shift Column Left / Shift Column Right or press hotkey Alt+Left/Alt+Right to move the current column leftward or rightward.

Copy

The item is for copying the selected row or multiple rows to the clipboard.

Select the target row/rows of data, and click Edit -> Copy or right-click to select Copy or press hotkey Ctrl+C to perform the copy operation.

Cut

The item is for cutting off data in the selected row or rows and pasting it to the clipboard.

Select the target row/rows of data, and click Edit -> Cut or right-click to select Cut to perform the cut operation.

Paste

The item is for pasting copied or cut data to a specific position.

Select a target position, and click Edit -> Paste or right-click to select Paste or press hotkey Ctrl+P to perform the paste operation.

Find

The item is used to search for the specified content in the current source data.

Click Edit -> Find to get the following Search and Replace dialog box:

Enter the content you want to find in the box after “Search for”, and among options “Case-sensitive”, “Match whole word”, “Ignore words in quotes” and “Ignore words in parentheses”, select or unselect what you want, and click “Search” button to display the first highlighted cell containing the target content.

Replace

The item replaces the specified content in the current source data with the other content.

Click Edit -> Replace to get the Find and Replace dialog. Enter the content you want to replace in the box after “Search for” and the content you want to replace with after “Replace with”, and among options “Case sensitive”, “Match whole words”, select or unselect what you want, and click “Replace” button to replace the first target or click “Replace all” to replace all targets.

 

Undo

The item is for cancelling the latest action or operation.

Click Edit -> Undo or press hotkey Crtl+Z to cancel the last action you did.

Redo

The item is for returning to the status before you perform Undo.

If you need to cancel what Undo does, click Edit -> Redo or press hotkey Ctrl+Y to return to the status before you click Undo.